Viewing 15 posts - 31 through 45 (of 58 total)
My wife doesn't get my sense of humor either.
March 17, 2006 at 9:51 am
What is the backup and restore syntax you are using? What is the error? Did the restore fail when you tried to restore the full db, or when...
March 17, 2006 at 9:48 am
Do you overwrite the database on the standby when you do your weekly copy? What happens if you lose the disk on your primary in the middle of the...
March 16, 2006 at 1:11 pm
Here's the code for a proc I use to kill all users for a database. It's not infallible, but it gets the job done most of the time. ...
March 16, 2006 at 12:23 pm
The database will be unavailable to users during the restore. Assuming you are using SQLServer's log shipping rather than a home grown solution, check the box for 'Terminate users...
March 15, 2006 at 10:04 pm
Are you creating the job through the 'Schedule Package...' option? if so, what happens if you create a job step calling DTSRUN /E...?
March 15, 2006 at 3:15 pm
I don't understand what you mean by multiple primary filegroups. By definition there is just one primary filegroup - the one with the system tables. How have you...
March 15, 2006 at 3:03 pm
Murali,
A couple of points. First, don't confuse 'BACKUP DATABASE...' with 'BACKUP LOG...' The former will perform a full backup of the database, including enough of the log to...
March 14, 2006 at 5:27 pm
Log shipping is supported in a Bulk-Logged database. The log backup includes both the logged transactions and the data pages from the bulk load operations. The 'minimally logged'...
March 14, 2006 at 4:23 pm
The defrag is fully logged in a series of small transactions. In a SIMPLE database, this means that earlier transactions can be truncated and their space in the log...
March 14, 2006 at 9:12 am
Not possible. The restore allows you to specify the placement of each file, but you cannot split a file to multiple locations.
March 13, 2006 at 1:25 pm
Yes, that will have the desired result. However, your log file is going to blow up when you do it, so make sure you have plenty of space for...
March 10, 2006 at 12:33 pm
I disagree. I perform full backups on my primaries on a regular basis and it does not break the chain. A full backup includes enough of the log...
March 9, 2006 at 12:30 pm
A transaction log backup is not simply a copy of the LDF file; it is a backup of all of the transactions executed since the previous log backup. In...
March 7, 2006 at 12:38 pm
Although I can't say exactly what the difference is, I have had problems related to these two collations conflicting.
As I recall, I restored a database with the old collation onto...
March 1, 2006 at 5:41 pm
Viewing 15 posts - 31 through 45 (of 58 total)