Viewing 15 posts - 5,176 through 5,190 (of 26,490 total)
Glad we were finally able to help you with this issue.
May 18, 2015 at 3:00 pm
Lynn Pettis (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.Must admire your patience Lynn!
😎
What,...
May 18, 2015 at 2:53 pm
briancampbellmcad (5/18/2015)
Isn't this for a database sored on my local machine? I'm trying to do it on a server based database.
No when run on the server it will restore a...
May 18, 2015 at 2:42 pm
amar_kaur16 (5/18/2015)
I have testdate and the yearago date from the testdate with studentid and subject usinfg this query :
select Studentid, Lname,Fname,testdate, subject...
May 18, 2015 at 2:39 pm
jralston88 (5/18/2015)
May 18, 2015 at 2:36 pm
RESTORE DATABASE BCCrestore
FROM DISK = 'D:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BCC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BCC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf',
REPLACE,
STATS = 10;
GO
May 18, 2015 at 2:31 pm
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.Must admire your patience Lynn!
😎
What, me patient?...
May 18, 2015 at 2:30 pm
briancampbellmcad (5/18/2015)
FROM DISK = 'D:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BBC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BBC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf',
REPLACE,
STATS = 10;
GO
Msg 3234, Level 16, State 2, Line 2
Logical file 'BBC' is not part of database...
May 18, 2015 at 2:28 pm
The restore command provided should work. I backed up my Sandbox database and restored it as Sandbox5. The following is the command I used:
USE [master]
RESTORE DATABASE [Sandbox5]
FROM ...
May 18, 2015 at 2:27 pm
briancampbellmcad (5/18/2015)
FROM DISK = 'C:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BBC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BBC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf',
REPLACE,
STATS =...
May 18, 2015 at 2:18 pm
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.Must admire your patience Lynn!
😎
What, me patient? Good thing you...
May 18, 2015 at 2:11 pm
David Webb-CDS (5/18/2015)
OK, let's try this:RESTORE DATABASE BCCrestore
FROM DISK = 'D:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BCC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BCC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf'
WITH REPLACE;
GO
Not quite. This:
RESTORE DATABASE BCCrestore
FROM DISK = 'C:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BBC'...
May 18, 2015 at 2:09 pm
briancampbellmcad (5/18/2015)
I want to restore to BCCrestore, not my production database. Are these safe to run?:restore headeronly from DISK = 'D:\BCC_DB_backup_201505020017.bak'
restore filelistonly from DISK = 'D:\BCC_DB_backup_201505020017.bak'
Yes, these don't restore a...
May 18, 2015 at 2:08 pm
ramana3327 (5/18/2015)
We have transactional log backup set up for every 15 min.
We are running default reorg indexes for all tables in one of our production...
May 18, 2015 at 2:06 pm
Run the following and post the results:
restore headeronly from DISK = 'D:\BCC_DB_backup_201505020017.bak'
restore filelistonly from DISK = 'D:\BCC_DB_backup_201505020017.bak'
May 18, 2015 at 1:53 pm
Viewing 15 posts - 5,176 through 5,190 (of 26,490 total)