Viewing 15 posts - 61 through 75 (of 148 total)
First ,thanks for the nice question ,I always used to thought it takes alter table command at the back end .
I have attached my results with client statistics .
Waiting for...
November 21, 2012 at 10:41 pm
Really Stupid I am ...
Thats Really Worth reading blog by Gail .
If your lucky,you will get your databases back...But anyone can realize the importance of backups from this...
November 21, 2012 at 12:21 am
did you try
EXEC sp_attach_single_file_db @dbname = 'MEDICALSTORE',
@physname =
N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MEDICALSTORE_Data.mdf';
November 20, 2012 at 11:31 pm
November 20, 2012 at 10:58 pm
anthony.green (11/20/2012)
First off, why no backups? System database are just as important to backup as your user backups. Please tell me you backup your Master database at least?
+10000000
November 20, 2012 at 6:11 am
nitin.doshi (11/20/2012)
November 20, 2012 at 3:56 am
alex_zilberman (11/19/2012)
also
I write the statement something like this:
Backup Database [db name]
to disk = N'Path to file'
with init, Name=N'full database backup', skip, stats=10;
Is this will not truncate...
November 19, 2012 at 12:59 am
Tanaji Chougale (11/19/2012)
all things are properthis application run properly on other normal PC
what you mean by all ?
what is
1)Physical memory
2)sql/winodows server configuration
3)which query getting performance issue
4)what is the...
November 19, 2012 at 12:53 am
Also I'm so much excited for the concert by Guns N Roses in dec 2012 (First time in INDIA) .
I know without slash ,it will not be...
November 17, 2012 at 1:27 am
I play Acoustic guitar from last few years .. not dedicated as so far. Just few days back bought new Yamaha F310, my second guitar and I love it .
I...
November 17, 2012 at 1:21 am
As long as its running successfully,it should not give wrong output.
Just curious,did you used NOLOCK hint anywhere inside SP ?
November 16, 2012 at 11:33 pm
bugg (11/16/2012)
Cheers I Have used the with restore, and changed fromSET SINGLE_USER WITH
ROLLBACK IMMEDIATE
TO
ALTER DATABASE Test_DB SET OFFLINE WITH ROLLBACK IMMEDIATE
Do you think this will suffice?
No ,database will not go...
November 16, 2012 at 11:20 pm
venkat.2829 (11/16/2012)
i have give as below
SQLCMD -S servername...
November 16, 2012 at 5:45 am
bugg (11/16/2012)
sanket kokane (11/16/2012)
--Drop previous reporting database
----------------------------------------------------------
PRINT 'Check if DB exists if so drop'
GO
IF EXISTS(SELECT * FROM SYS.DATABASES WHERE NAME='ReportDB')
BEGIN
--Remove any connections
ALTER DATABASE ReportDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
--Drop DB
DROP DATABASE ReportDB
END
GO
setting...
November 16, 2012 at 5:40 am
Viewing 15 posts - 61 through 75 (of 148 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy