Viewing 15 posts - 1 through 15 (of 60 total)
There will be an impact of backup on production system. try to take backup in non peak time or take a strip backup.
May 9, 2012 at 12:49 pm
Check your sql server authentication mode windows or mixed mode?
May 9, 2012 at 12:43 pm
May 7, 2012 at 11:50 pm
Why you only want database roles information from snapshot database. If the snapshot is queried for data on any page that has not been modified in the source database, since...
May 7, 2012 at 9:06 pm
It will give more light if you post the query also.
May 7, 2012 at 8:56 pm
Please check this alert.
http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/
May 5, 2012 at 10:36 am
When you changed the database into simple recovery by default check point flushed the committed logs. so now its not require to take a log backup.
May 2, 2012 at 11:51 am
If production server failed then copy job will start failing and you can keep notifictation on failure of this job.
After getting notification you can start to dig the issue and...
May 1, 2012 at 7:31 am
Yes you can upgrade. just have a look on this
http://www.techrepublic.com/blog/10things/10-tips-for-upgrading-to-sql-server-2008-r2/2376
April 28, 2012 at 2:46 pm
1. Arrange some more space or if you space othe drive then try to take strip backup.
2. get any backup compression tool like redget or litespeed.
April 28, 2012 at 2:36 pm
Viewing 15 posts - 1 through 15 (of 60 total)