No announcements
Found 1572506 threads
-
0 VotesPerformPostRestoreFixup table limit and Timeout
For now, you have to sync less than or equal 255 tables in a database.Answered | 2 Replies | 8382 Views | Created by Jorge Leal - Sunday, January 31, 2010 11:36 AM | Last reply by Montago - Wednesday, December 8, 2010 8:42 AM
-
3 Votes
Database restore before test runs
When tests complete, you just need to restore the database.Answered | 7 Replies | 4386 Views | Created by PS81 - Wednesday, November 5, 2008 11:29 PM | Last reply by PS81 - Wednesday, November 19, 2008 6:55 PM -
0 Votes
Running a restore database with error handling
So what if you just run the BACKUP though SQLCMD?Answered | 10 Replies | 2356 Views | Created by Serge Calderara - Wednesday, January 2, 2013 1:16 PM | Last reply by Erland Sommarskog - Monday, January 7, 2013 2:20 PM -
0 Votes
Dynamically Creating and Running a Database Restore Command
I am restoring a production database to our development system, which is on a different server.Answered | 8 Replies | 2928 Views | Created by Gregory Coles - Wednesday, June 17, 2015 5:51 PM | Last reply by Gregory Coles - Thursday, June 18, 2015 4:02 PM -
0 Votes
Restore Database
I would ad to Warwik Rudd reply that before you move the old database (SQL Server 2000) run Upgrade Advisor to identify deprecated commands or objects....Answered | 4 Replies | 8975 Views | Created by Madison Le - Friday, October 21, 2011 6:55 PM | Last reply by Uri Dimant - Monday, October 24, 2011 6:28 AM -
0 Votes
Restoring database state for each test run.
Just write your restore code in: //Use TestInitialize to run code before running each ...Answered | 3 Replies | 3302 Views | Created by SharathChandra - Wednesday, December 17, 2008 3:31 PM | Last reply by SharathChandra - Tuesday, December 23, 2008 9:39 AM -
2 Votes
restoring database
The last post by Weiyan Zhong_SQL_-MSFT suggested that I can generate a script for database and run the script on SQL Server 2000.Answered | 11 Replies | 8054 Views | Created by prince-obi - Monday, January 31, 2011 1:49 PM | Last reply by Vishal Gajjar - Tuesday, February 1, 2011 9:11 AM -
0 Votes
Restore database
RESTORE FILELISTONLY FROM DISK='C:\MyBackup\Customer_Production.bak' If Customer_Development database ...Answered | 6 Replies | 1451 Views | Created by MikeGanem2 - Thursday, April 21, 2016 4:42 PM | Last reply by Jason_Clark03 - Friday, April 22, 2016 8:29 AM -
1 Votes
Restoring Database
Check if the restore is being blocked (sp_who2 active)Run the restore with stats =1 to see the progress every 1 percentCheck the wait_type of the spid executing ...Answered | 5 Replies | 2134 Views | Created by xLinhx - Tuesday, January 13, 2015 2:51 AM | Last reply by Satheesh Variath - Tuesday, January 13, 2015 9:19 AM -
0 Votes
Restoring database
If you have backups then follow these steps: 1) Reinstall SQL Server 2) Restore the master database as described ...Answered | 4 Replies | 759 Views | Created by IsraelSilberg - Monday, April 9, 2018 4:59 AM | Last reply by Martin.Cairney - Monday, April 9, 2018 8:18 AM -
4 Votes
database restore
We currently dont' have transaction log backup running and just full database backup.Answered | 20 Replies | 4126 Views | Created by alexsql - Friday, October 19, 2012 6:20 PM | Last reply by Sean Gallardy - Monday, November 5, 2012 2:40 PM -
0 Votes
Restoring a database
To solve this issue, you need both files to restore your database.Answered | 4 Replies | 1212 Views | Created by chaitanya dhole - Friday, October 16, 2015 5:39 AM | Last reply by Lydia Zhang - Monday, October 19, 2015 7:13 AM -
0 Votes
database restore
As you have got relevant replies to accomplish the task, the reason for hour glass is due to restricted procedures to RESTORE system databases you have to take help of scripts ...Answered | 3 Replies | 6101 Views | Created by uaealms - Sunday, August 30, 2009 8:43 AM | Last reply by Satya SKJ - Tuesday, September 1, 2009 9:49 AM -
0 Votes
Restore Database
Hi Muhammad, It seems that your current login has no permission to restore database.Answered | 2 Replies | 6010 Views | Created by MM from AUS - Wednesday, October 5, 2011 9:21 PM | Last reply by Iric Wen - Friday, October 7, 2011 8:44 AM -
0 Votes
Database restore
It recreates the database and pushes tables with data and all other objects in the SQl 2005 database compatible with 2000 engine.Answered | 2 Replies | 18780 Views | Created by jituranjan - Monday, February 1, 2010 5:52 PM | Last reply by Lekss - Monday, February 1, 2010 8:18 PM -
1 Votes
Restore Databases
You can run the following script to find out which users are out of sync.Answered | 5 Replies | 7709 Views | Created by CrazyColombian - Monday, April 5, 2010 8:18 PM | Last reply by CrazyColombian - Tuesday, April 6, 2010 2:00 PM -
1 Votes
Restore database
How to Restore Database in SQL Server - Steps to Restore a Full Database Back Up Cheers, Ashish Kumar ...Answered | 4 Replies | 3736 Views | Created by Maheshwar Reddy - Tuesday, May 15, 2012 3:50 PM | Last reply by Ashish Kumar Mehta - Wednesday, May 16, 2012 5:42 AM -
0 Votes
Restoring Database
The database isn't accessible, but the ldf file(s) ...Answered | 2 Replies | 6003 Views | Created by Sengwa - Tuesday, April 27, 2010 6:02 PM | Last reply by TiborK - Tuesday, April 27, 2010 7:06 PM -
2 Votes
database restore
Just run windows update....Answered | 6 Replies | 4902 Views | Created by sandeep496 - Monday, April 12, 2010 12:23 PM | Last reply by sandeep496 - Monday, April 19, 2010 12:11 PM -
0 Votes
Database Restore
Try SELECT TOP 10 * FROM restorehistory WITH (nolock)WHERE (destination_database_name = 'Database Name')ORDER BY ...Answered | 4 Replies | 1657 Views | Created by subu999 - Tuesday, November 27, 2012 4:37 AM | Last reply by Olaf Helper - Tuesday, November 27, 2012 5:28 AM - Items 1 to 20 of 1572506 Next ›
No announcements
