That didn't work for us. The caption for that setting indicates it is only for error log files. We needed to make the change in the registry.

Hello All, I am always using SQL Server Management Studio for backup and restore databases in SQL Server 2005. I just want to know about how to take backup and restore the databases using Query Analyser. Please help me regarding this topic Regards Ansar V M

I have a SQL 2005 SP 2 server running a maintenance plan that performs full backups every day at 22:00, diff backups every 4 hours and log backups every 30 minutes. The plan backs up all system & user databases (all user DBs are in Full recovery mode). The full & log backups all complete and...

Our one production db is 48 gb and it takes more than an hour to take back up .We are thinking to reduce the back up time .The data files are on san drives and the back up too is going to the san drive .The temp db also is on the san and is on the same drive as data drive Does temp db is involved in...

Below you find a stored procedure to copy data from one database to another. It looks for identical tables and then within the tables found, looks for identical column names. When found, an insrt query is created and data is copied. Good luck USE [Tele] --the name of the database I'm in GO /****...

Hi All, I have a database with like 500gigs on orimary .mdf file and like3 .ndf files of around 50 GB and if i take the backup and restore it back would it distribute data evenly across all four files or file pattern would still remain same. Thanks to all.

Hi all I always get the error in Log file viewer which is Source spid400 Message I/O is frozen on database databasename. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup. and the very next message is Source spid400 Message I/O was resumed on database databasename...

We have a 50 gb database and we are taking daily full backup and 9am to 6pm daily transaction log backup.We wish to change the schedule 1) Weekly full backup and daily differential backup.Currently the total( 9 times ) daily transaction log come up to 3GB and the sum of all time taken to compleate the...