Viewing 15 posts - 631 through 645 (of 1,179 total)
Try this:
Step 1:
alter database dbname
set single_user
with rollback immediate
Step 2: (Immediately after Step 1)
Restore database dbname from device = '<filepath>'
Your databae will be in multi_user mode after the restore. If not...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 28, 2011 at 12:10 am
Expand the log file size and set autogrow on; if your datatabase is production. If not you can put database in simple recovery mode.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 28, 2011 at 12:05 am
If you have configured database mail; check your mail profile by sending test mail.
http://msdn.microsoft.com/en-us/library/ms190307.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 28, 2011 at 12:02 am
In addition to above, check if the SORT_IN_TEMPDB option is set to ON while rebuilding indexes than SQL Server will use tempdb.
Check following article for further detail.
http://msdn.microsoft.com/en-us/library/ms188281.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 27, 2011 at 11:08 pm
Thanks Jeff, good question.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 27, 2011 at 3:36 am
Yes, you can configure Database Mail or SQL Mail. I prefer Database mail.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 23, 2011 at 3:18 am
Sonds good.
You can also disable any constraints, business rues, checks etc before BCP and once BCP is done enable it. Also if possible you can use TABLOCK hint.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 23, 2011 at 3:11 am
You can use SSIS to transfer logins.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 22, 2011 at 5:20 am
You need to check with your mobile service provider and ask for mail address for your mobile number. e.g. in some of the case mobilenumber@serviceprovider.com where you need to put...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 21, 2011 at 1:52 am
As explained above, if you do not have space issue go with LS. This will help you to minimize the donwtime too.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 22, 2011 at 4:43 am
Both collation are same. There is no difference in collation eventhough SQL Server version changes. I prefer to install the same collation of SQL SERVER 2008 as SQL Server 2000.
Cheers!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 21, 2011 at 6:35 am
You are correct LS is ont timezone aware and it based on LSN.
What you can do here is you need to set up LS manually or write step of restore...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 21, 2011 at 6:08 am
Option 1:[/u] You can either perform rebuild/defrag indexes on existing box before do the full backup
or
Option 2: rebuild/defrag indexes on the new box after the restore.
Now, if your existing...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 21, 2011 at 5:54 am
Enable traceflag 3605 which will help you to capture the information in sql log. Refer following link for further detail:
http://support.microsoft.com/kb/832524
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 20, 2011 at 3:18 am
Nice Question!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 20, 2011 at 1:07 am
Viewing 15 posts - 631 through 645 (of 1,179 total)