Viewing 15 posts - 166 through 180 (of 815 total)
data will always be available as long your backup and restore jobs are working fine, if you considering log shipping.
September 12, 2011 at 6:33 am
if the secondary server can be flexible enough(not exactly 1 min behind the prod server then log shipping is still the valid option (as you will not be generating the...
September 12, 2011 at 3:06 am
kutemom09 (9/11/2011)
September 12, 2011 at 1:52 am
have a look of this thread
http://www.sqlservercentral.com/Forums/Topic501078-5-1.aspx
you might get some help here.
August 18, 2011 at 9:30 pm
sehgalnamit (8/18/2011)
jobs, ssis exists in msdb.
ohhh thanks, at least you know that.
August 18, 2011 at 9:14 pm
But in SQL 2005, when i right click
Database Maintenance Plans in Legacy, I dont get Migrate, I have only View History.
I am using SQL 2005 EE.
you need...
August 18, 2011 at 6:54 am
if you can access google then you will get this result for your search
August 18, 2011 at 6:45 am
save them as DTS and transfer them in to sql 2005 SSIS
August 18, 2011 at 5:20 am
I am looking for for trasferring all metadata to my DR server everyday which includes linked servers, logins, system roles, system databases access etc...sql server jobs.
in short master database
August 18, 2011 at 12:47 am
As per my understanding, 0 is for the default configuration as set up in database server.
Related to number of user not able to login, it seems like application issue not...
August 17, 2011 at 12:23 am
next time instead of directly restarting the sql service, you may try first to bring database offline/online
August 17, 2011 at 12:17 am
Thanks for sharing. I will have a look.
August 5, 2011 at 7:07 am
Thanks for the msdn link. It created the user,roles and login. I am looking for some script which can generate all permission for all users in a perticular database.
I have...
August 5, 2011 at 12:44 am
sehgalnamit (8/3/2011)
Can we shrink the database files while restoring from backup?
why not shrink before taking backup.
PS:- Shrink should be avoided for day to day operation.
August 3, 2011 at 4:09 am
Assuming you are using sql 2008.
RightClick on your database--Tasks--GenerateScripts for users.
Take this script in a file and schedule it as per your requirement. It will not affect the existing...
August 3, 2011 at 4:07 am
Viewing 15 posts - 166 through 180 (of 815 total)