Viewing 15 posts - 961 through 975 (of 3,738 total)
I created the maintenance plans and I had to copy and paste the T-SQL Code for the Plan/Job would not run.
November 29, 2013 at 10:35 am
Perry Whittle (11/29/2013)
which version\edition of sql server are you using?
I'm moving from SQL Server 2005 RTM to SQL Server 2008 R2 and 2012 in the near future.
The server has about...
November 29, 2013 at 8:43 am
homebrew01 (11/27/2013)
Have you tried using the GUI to set up the restore, then generate the script to a query window ?
Thanks. I restored through the GUI which I never do...
November 27, 2013 at 2:58 pm
RESTORE FILELISTONLY
FROM DISK = 'M:\Backup_2005\Complete\YAFNET_backup_2013_11_21_192534_3162500.bak'
GO
LogicalNamePhysicalNameTypeFileGroupNameSize
YAFNETZ:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\YAFNET.mdfDPRIMARY4390912
YAFNET_logZ:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\YAFNET_log.LDFLNULL5308416
sysft_YafSearchZ:\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\YafSearchFPRIMARY468974
RESTORE FILELISTONLY
FROM DISK = 'M:\Backup_2005\Complete\YAFNET_backup_2013_11_21_192534_3162500.bak'
GO
RESTORE DATABASE YAFNET
FROM DISK =
WITH REPLACE,
RECOVERY,
MOVE '' TO 'M:\MSSQL\Data\',
MOVE '' TO 'M:\MSSQL\Log\'
November 27, 2013 at 10:17 am
I atttached the word work with screen shot and tried to open myself but I could not open it?
How can I embed an image intop my post?
Thanks.
November 27, 2013 at 10:14 am
Restarted the Service and fixed an orphan user.
Back in business.
November 19, 2013 at 10:43 am
I noticed that my Transaction Log for a Database was over 25 GB.
Then I checked and saw that the full backup had been running for over 10 Hours.
Then I noticed...
November 13, 2013 at 6:48 am
Bhuvnesh (11/7/2013)
Welsh Corgi (11/7/2013)
Cool script.Thanks everyone.
Did you find the issue ?
Case closed.
Thank you.
November 7, 2013 at 7:43 am
Cool script.
Thanks everyone.
November 7, 2013 at 6:33 am
Bhuvnesh (11/7/2013)
Did you miss colon (:) before your drive letter I it should be'I:\MSSQL\log\MyDW.ldf'
Dah.:blush:
Thank you.
November 7, 2013 at 5:25 am
chandan_jha18 (11/7/2013)
sqlnaive (11/7/2013)
Interesting read. Gives the pretty much idea on what you can end up into if not consider the impact of the DML.
Burned my hands with heavy deletes once,...
November 7, 2013 at 4:59 am
GilaMonster (11/6/2013)
A DB will go restoring if someone runs BACKUP LOG ... WITH NORECOVERY or runs a restore over the database and specifies NORECOVERY. In either case running...
November 6, 2013 at 3:20 pm
Recovery completed.
Thanks for the help.:-)
November 6, 2013 at 10:09 am
Recovery at 88% Complete.
Keeping my fingers crossed. 🙂
November 6, 2013 at 8:26 am
Viewing 15 posts - 961 through 975 (of 3,738 total)