Viewing 15 posts - 166 through 180 (of 812 total)
data will always be available as long your backup and restore jobs are working fine, if you considering log shipping.
----------
Ashish
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...
----------
Ashish
September 12, 2011 at 3:06 am
kutemom09 (9/11/2011)
----------
Ashish
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.
----------
Ashish
August 18, 2011 at 9:30 pm
sehgalnamit (8/18/2011)
jobs, ssis exists in msdb.
ohhh thanks, at least you know that.
----------
Ashish
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...
----------
Ashish
August 18, 2011 at 6:54 am
if you can access google then you will get this result for your search
http://msdn.microsoft.com/en-us/library/bb153838.aspx
----------
Ashish
August 18, 2011 at 6:45 am
save them as DTS and transfer them in to sql 2005 SSIS
----------
Ashish
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
----------
Ashish
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...
----------
Ashish
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
----------
Ashish
August 17, 2011 at 12:17 am
Thanks for sharing. I will have a look.
----------
Ashish
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...
----------
Ashish
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.
----------
Ashish
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...
----------
Ashish
August 3, 2011 at 4:07 am
Viewing 15 posts - 166 through 180 (of 812 total)