Viewing 15 posts - 2,011 through 2,025 (of 19,560 total)
whereisSQL? (9/24/2014)
SQLRNNR (9/24/2014)
BWFC (9/24/2014)
Ouroborosburro de oro
burrito
burr filled dough
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 24, 2014 at 10:39 am
sestell1 (9/24/2014)
Arrrrr.... it be a shame ta not be postin' this question on September 19!
+10
Missed opportunity thar
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 24, 2014 at 8:17 am
BWFC (9/24/2014)
Ouroboros
burro de oro
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 24, 2014 at 8:14 am
Ed Wagner (9/24/2014)
Sean Lange (9/24/2014)
Ed Wagner (9/24/2014)
TomThomson (9/24/2014)
BWFC (9/24/2014)
BiteBark
Tree
Pith
Pithy
Python
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 24, 2014 at 7:43 am
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 6:20 pm
If this were an actual disaster recovery, then you would want a tail log backup. But that isn't the case here.
You might want to read up on a few...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 4:17 pm
It is because you did not specify the replace key word.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 4:15 pm
Tail log backup is not necessary on the target before you do a restore.
The replace let's it know you are "replacing" the database with the backup you specified.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 4:06 pm
Try this instead
Restore database Test1
from disk ='\\Test\DBdumps\test1.bak
with recovery,replace
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 3:35 pm
Alter the database and perform the restore from the master database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 2:45 pm
After you restore the database you will want to ensure it is back to multi_user mode.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 1:59 pm
Have you confirmed that the path is reachable from your server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 1:43 pm
Restricted user just changes it so only users with elevated perms can access the database. It does not prevent multiple connections from being established and preventing the restore.
You will...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 1:09 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 12:32 pm
ramana3327 (9/23/2014)
Correct me my understand is wrongso compare to the copy the backup into the local and restore, it is better to restore from network
No. It is better to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 12:28 pm
Viewing 15 posts - 2,011 through 2,025 (of 19,560 total)