Viewing 15 posts - 13,276 through 13,290 (of 22,227 total)
mw112009 (2/14/2011)
Grant Fritchey (2/14/2011)
mw112009 (2/14/2011)
When I started the "RESTORE.." I used the query window in SSMS.
Then 4 hours later when I logged back into the server...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 9:20 am
mw112009 (2/14/2011)
When I started the "RESTORE.." I used the query window in SSMS.
Then 4 hours later when I logged back into the server I did not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 7:57 am
sjimmo (2/14/2011)
restore database NGProd
from disk = N'D:\Backups\NGProd.bak' with file = 1,
move 'NextGen_System_Data' to 'D:\Databases\NGProd\NGProd_System_data.mdf',
move 'NextGen_Core_Data_1' to 'D:\Databases\NGProd\NGProd_Core_Data_1.ndf',
move 'NextGen_Index_1' to 'D:\Databases\NGProd\NGProd_Index_1.ndf',
move 'NextGen_Log' to 'D:\Databases\NGProd\NGProd_Log.ldf',
recovery,
stats = 10;
As an FYI -...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 7:09 am
mw112009 (2/14/2011)
I did the same ( using the same portable hard drive and the exact copy ) but using a server ( The server was...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 7:02 am
mw112009 (2/14/2011)
pankushmehta (2/13/2011)
Can you copy the file to the server and then run the restore?
No can not copy the backup file to the server.
Reason: Our sever has very limited space....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 6:38 am
SKYBVI (2/14/2011)
Wat abt maintanence plans running under user 'sa'?Regards,
Sushant
Those are usually running from SQL Agent and should not be an issue. If you call them in other ways, all bets...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 6:11 am
iyyappan.murugappan (2/13/2011)
Thanks for your suggestion, But I already tried Red Gate some time back. I dropped this software due to following issues.
01. Not able to restore if the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 6:07 am
Agent jobs that run as sa don't use the password (or at least, they shouldn't), but yes, if you have apps that are dependent on the SQL 'sa' login, they...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 5:45 am
If you can, while this procedure is running, run a select statement against sys.dm_exec_requests. You should be able to see the procedure (if not, combine it with sys.dm_exec_sql_text and use...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 5:43 am
But, you only get one primary key per table. You can have multiple unique keys, but only one primary key.
I'm with everyone else, what exactly are you looking for here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 5:40 am
Personally, I'd want to have a chat with the interviewer. Most of the time, and by that I mean 99.several nines, you have something wrong in the query that is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 5:18 am
150gb should restore fairly quickly. What was the command you used to do the restore?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 5:14 am
Craig Farrell (2/13/2011)
One of the things that will help...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 5:08 am
george sibbald (2/13/2011)
Grant Fritchey (2/13/2011)
SCOM from MS is good, and certainly enterprise ready. You can get Management Packs that do most of what you're asking about right out of the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 5:07 am
WayneS (2/13/2011)
Grant Fritchey (2/8/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 5:01 am
Viewing 15 posts - 13,276 through 13,290 (of 22,227 total)