Viewing 15 posts - 136 through 150 (of 366 total)
What did you do before you restarted the Server?
Nothing Just a restart of the sql service
Check the default database for the User.
Master database
Is it offline or in suspect mode, etc?
No
Did...
July 24, 2011 at 9:35 pm
Yup. These backups aren't been taken with checksum, so all restore verifyonly is doing is verifying that the backup header is intact. The backup itse4lf can be absolutely destroyed, the...
June 17, 2011 at 2:37 pm
In my backup procedure, Restore verifyonly taking much time once the backup is done.
RESTORE VERIFYONLY FROM DISK = @BackupPath
WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
Question: Is my...
June 17, 2011 at 10:13 am
Have you verified the directory exists and permissions are there
Yes. The path Z:\Backups does not exist.
The path that exist is Z:\Logshipping_Backups (the path mentioned for copying the log backup files...
June 15, 2011 at 12:13 pm
Could you please advice me..I'm getting this error on Production Server daily once
June 15, 2011 at 11:30 am
Yes, Verify backup is there in the backup script.
Here is my Backup Stored procedure:
Questions:
1. Is my Backup procedure good enough to take a backup of a Production database?
2. Please...
June 14, 2011 at 9:47 am
dbo.BackupDB is stored procedure used to backup a database and there is NO other step inthe backup job.
Just backing up the 200 GB content database.
June 13, 2011 at 5:54 pm
No. I did check again and there is only one database backing in that job step. Nothing else.
Job Step:
EXEC [dbo].[BackupDB] 'WSS_Content_PROD','Z:\Backups\FULL\','FULL'
GO
Please advice...
June 13, 2011 at 3:52 pm
Looks like you forgot to place the script!!
January 26, 2011 at 3:49 pm
If we cannot use Wizard, then can we just run log backups every 15 mins and then set up a copy job to copy to secondary and a restore job...
January 26, 2011 at 12:06 pm
There's no command to do that. Script out the pk and the other stuff using management studio, then use CREATE TABLE and INSERT INTO rather than SELECT INTO.
Thanks Gail,
I have...
January 20, 2011 at 11:42 am
SELECT ... INTO just creates the table. Nothing more. If you want constraints, indexes, defaults or anything like that you'll have to add them afterwards, or explicitly create the table...
January 17, 2011 at 4:03 pm
Now the user Test is able to access the Standby mode database on secondary instance. Thank you..
January 14, 2011 at 10:22 am
On live server, I got the SID of the login and I'm trying to create the login on secondary server as below:
Create Login [Test]
With SID = '0xE1EDB47AD4DEB243A4AA578ACBE92700',
Password = 'Passw0rd'
In above...
January 13, 2011 at 7:09 pm
Hi, I have performed the below steps:
1. on production server(Primary sql server instance), Created a sql server login called Test and mapped the login to the database Mydb
2. Granted db_datareader...
January 13, 2011 at 4:10 pm
Viewing 15 posts - 136 through 150 (of 366 total)