Viewing 15 posts - 37,636 through 37,650 (of 39,509 total)
April 15, 2002 at 11:02 am
April 15, 2002 at 10:58 am
You can also use differentials to minimize your risk. If you made a 12:30 differentials, then the corrupt 12:25 would not matter. You'd do the 12:00 full, the 12:30 diff,...
April 15, 2002 at 10:57 am
You would need to write a script that can move the database defaults for the users. There is not a way for SQL to know this (unless you copy the...
April 15, 2002 at 10:53 am
AFAIK, you will need some script to do this. There might be one on this site. In EM you can see the user permissions, but need to check the...
April 15, 2002 at 10:51 am
Try a couple things:
Log in as UserX in QA, note the default db. Check EM and the properties for this login and note this.
Restart SQL and repeat.
Now change the default...
April 15, 2002 at 10:03 am
Good suggestion. I will add it to the list of things we have for enhancements.
Steve Jones
April 12, 2002 at 3:20 pm
you can run in simple more, which will truncate the log and essentially work without one, but some things will still be logged.
Steve Jones
April 12, 2002 at 11:10 am
April 12, 2002 at 11:10 am
Backup and restore. This will not move logins, but you can move these by extracting them from master..syslogins and adding them to the new server.
A better idea is to install...
April 12, 2002 at 10:13 am
It is possible. I think you will find the consensus among most experienced DBAs is to backup to disk, then get these to tape.
If you experienced this crash, you would:
...
April 12, 2002 at 10:10 am
April 12, 2002 at 10:07 am
April 11, 2002 at 3:47 pm
You can use a data driven query (I believe ) to do this, but it's too complex in my opinion.
I usually do this with a tempload table that is strictly...
April 11, 2002 at 3:34 pm
Use a varbinary or image datatype and then store the document like you would an image using ADO.
Steve Jones
April 11, 2002 at 12:27 pm
Viewing 15 posts - 37,636 through 37,650 (of 39,509 total)