SQL Backup and Restore « SQL Server Journey with SQL Authority

Archive for the ‘SQL Backup and Restore’ Category

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on May 27, 2011 | 18 Comments »

SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS. Make sure you have SQL Server Agent Turned on as this feature will create a job. The same job will execute the task. Make sure that SSIS is properly configured as well with [...]

Read Full Post »

SQL SERVER – Making Database to Read Only – Changing Database to Read/Write

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on April 16, 2011 | 4 Comments »

I recently received following comments on my earlier blog: “Today i was trying to attach the (MDF,NDF,LDF ) sql server 2008 database which i have received from my client. After attachment the database status is showing (Read-Only) (Eg.database name (Read-Only). How do i make to normal mode for the data updation. is there any query [...]

Read Full Post »

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on April 13, 2011 | 11 Comments »

Recently I formatted my computer and installed fresh SQL Server in it. I installed AdventureWorks database in my database. Once done I wanted to run few test scripts on my database. Just like every DBA, I decided to take backup of my database – this way I can restore it back to attain original database [...]

Read Full Post »

SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 19, 2011 | 10 Comments »

After reading my earlier article SQL SERVER – master Database Log File Grew Too Big, I received an email recently from another reader asking why does the log file of model database grow every day when he is not carrying out any operation in the model database. As per the email, he is absolutely sure [...]

Read Full Post »

SQL SERVER – master Database Log File Grew Too Big

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on January 9, 2011 | 14 Comments »

Couple of the days ago, I received following email and I find this email very interesting and I feel like sharing with all of you. Note: Please read the whole email before providing your suggestions. “Hi Pinal, If you can share these details on your blog, it will help many. We understand the value of [...]

Read Full Post »

« Newer Posts - Older Posts »