to copy your database to a new database on the same server
CREATE DATABASE Database1B AS COPY OF Database1A;
CREATE DATABASE Database1B AS COPY OF Database1A;
Showing posts with label Backup. Show all posts
Showing posts with label Backup. Show all posts
Wednesday, 14 November 2012
Thursday, 8 September 2011
MS Backup failed to complete creation of shared protection point
if your windows 2008 R2 backup is failing because shadow copy of disks takes too long and timeout, follow the instructions below and set the time accordingly.
Windows Server Backup is timing out during shadow copy creation since it is taking more than 10 minutes.
You can try increasing the timeout value to 20 minutes and see if that fixes this issue?
This involves updating a registry key. Hence please do this carefully.
- Run regedit.exe and navigate to L"HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\SPP"
- Create a new Registry value of type DWORD with name "CreateTimeout"
- Change value to 12000000(2*10*60*1000 = 20 mins) in decimal
Re-run backup and check if it succeeds now.
Windows Server Backup is timing out during shadow copy creation since it is taking more than 10 minutes.
You can try increasing the timeout value to 20 minutes and see if that fixes this issue?
This involves updating a registry key. Hence please do this carefully.
- Run regedit.exe and navigate to L"HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\SPP"
- Create a new Registry value of type DWORD with name "CreateTimeout"
- Change value to 12000000(2*10*60*1000 = 20 mins) in decimal
Re-run backup and check if it succeeds now.
Subscribe to:
Posts (Atom)