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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 29, 2013 at 8:43 am
Thanks.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 29, 2013 at 8:14 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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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\'
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 27, 2013 at 10:14 am
Restarted the Service and fixed an orphan user.
Back in business.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 7, 2013 at 7:43 am
Cool script.
Thanks everyone.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 6, 2013 at 3:20 pm
Recovery completed.
Thanks for the help.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 6, 2013 at 10:09 am
Recovery at 88% Complete.
Keeping my fingers crossed. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 6, 2013 at 8:26 am
Viewing 15 posts - 961 through 975 (of 3,738 total)