Release Database Transaction Log Used Space After Database Backup

What are the SQL Server commands that will shrink or release database
transaction log used disk space afer the database backup has completed?
Thank You,These two things are not related. A database backup will not empty the log.
A log backup will,
however. To then shrink the log file, use DBCC SHRINKFILE. But read
http://www.karaszi.com/SQLServer/info_dont_shrink.asp first.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:85D71BCF-F22C-4035-8A02-16771C713B58@.microsoft.com...
> What are the SQL Server commands that will shrink or release database
> transaction log used disk space afer the database backup has completed?
> Thank You,

Release Database Transaction Log Used Space After Database Backup

What are the SQL Server commands that will shrink or release database
transaction log used disk space afer the database backup has completed?
Thank You,These two things are not related. A database backup will not empty the log. A log backup will,
however. To then shrink the log file, use DBCC SHRINKFILE. But read
http://www.karaszi.com/SQLServer/info_dont_shrink.asp first.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:85D71BCF-F22C-4035-8A02-16771C713B58@.microsoft.com...
> What are the SQL Server commands that will shrink or release database
> transaction log used disk space afer the database backup has completed?
> Thank You,

Re-installing SQL SERVER

I have to install SQL Server onto a new PC and then restore the data from
tape backup to the new server.
Are there any special things I have to do...I have never done this before,
so I am unsure of the steps...
Basically, I will be doing this
Setup new PC
Install SQLSERVER
Make sure no server procedures are running on system startup
Restore databases from tape backup to new SQL SERVER build
Is there anything else I need to do? Delete MASTER.MDB?
Thx
read these two articles
http://support.microsoft.com/default...b;EN-US;224071
http://support.microsoft.com/default...b;EN-US;246133
it makes things a little simpler if you keep the exact same drive letter
and directory structure on your new server as on the old server.
Billy wrote:
> I have to install SQL Server onto a new PC and then restore the data from
> tape backup to the new server.
> Are there any special things I have to do...I have never done this before,
> so I am unsure of the steps...
> Basically, I will be doing this
> Setup new PC
> Install SQLSERVER
> Make sure no server procedures are running on system startup
> Restore databases from tape backup to new SQL SERVER build
> Is there anything else I need to do? Delete MASTER.MDB?
> Thx

Re-installing SQL SERVER

I have to install SQL Server onto a new PC and then restore the data from
tape backup to the new server.
Are there any special things I have to do...I have never done this before,
so I am unsure of the steps...
Basically, I will be doing this
Setup new PC
Install SQLSERVER
Make sure no server procedures are running on system startup
Restore databases from tape backup to new SQL SERVER build
Is there anything else I need to do? Delete MASTER.MDB?
Thxread these two articles
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
http://support.microsoft.com/default.aspx?scid=kb;EN-US;246133
it makes things a little simpler if you keep the exact same drive letter
and directory structure on your new server as on the old server.
Billy wrote:
> I have to install SQL Server onto a new PC and then restore the data from
> tape backup to the new server.
> Are there any special things I have to do...I have never done this before,
> so I am unsure of the steps...
> Basically, I will be doing this
> Setup new PC
> Install SQLSERVER
> Make sure no server procedures are running on system startup
> Restore databases from tape backup to new SQL SERVER build
> Is there anything else I need to do? Delete MASTER.MDB?
> Thxsql

Re-installing SQL SERVER

I have to install SQL Server onto a new PC and then restore the data from
tape backup to the new server.
Are there any special things I have to do...I have never done this before,
so I am unsure of the steps...
Basically, I will be doing this
Setup new PC
Install SQLSERVER
Make sure no server procedures are running on system startup
Restore databases from tape backup to new SQL SERVER build
Is there anything else I need to do? Delete MASTER.MDB?
Thxread these two articles
http://support.microsoft.com/defaul...kb;EN-US;224071
http://support.microsoft.com/defaul...kb;EN-US;246133
it makes things a little simpler if you keep the exact same drive letter
and directory structure on your new server as on the old server.
Billy wrote:
> I have to install SQL Server onto a new PC and then restore the data from
> tape backup to the new server.
> Are there any special things I have to do...I have never done this before,
> so I am unsure of the steps...
> Basically, I will be doing this
> Setup new PC
> Install SQLSERVER
> Make sure no server procedures are running on system startup
> Restore databases from tape backup to new SQL SERVER build
> Is there anything else I need to do? Delete MASTER.MDB?
> Thx

Reinstalling DB Server - Backup/Restore Help

Hi,
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>

Reinstalling DB Server - Backup/Restore Help

Hi,
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>

Regular Backup co-exist with log-shipping (or SQL mirroring)

Suppose I have a 3rd party SQL backup software to backup my databases, can I also setup a stand-by server for log shipping?

I'm not sure if this is possible? If not, is SQL mirroring a choice instead of log shipping?

Thanks a lot!

The only restriction is that only one thread of log backups can exist.

So, if your 3rd-party backup software is also doing log backups, log shipping will not work.

Alternatively, you can do full backups with your 3rd-party software and log shipping will work just fine.

Mirroring has no such restrictions.

Regular Backup co-exist with log-shipping (or SQL mirroring)

Suppose I have a 3rd party SQL backup software to backup my databases, can I also setup a stand-by server for log shipping?

I'm not sure if this is possible? If not, is SQL mirroring a choice instead of log shipping?

Thanks a lot!

The only restriction is that only one thread of log backups can exist.

So, if your 3rd-party backup software is also doing log backups, log shipping will not work.

Alternatively, you can do full backups with your 3rd-party software and log shipping will work just fine.

Mirroring has no such restrictions.